{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Indice","Esquema","Radiografia del gasto","CM_Produccion","CM","Notas","Notas_contables","Configuracion","GRAFICO1","GRAFICO2","Configuracioncopia"],"not_rendered":{"charts":10,"images":25,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Indice","index":0,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,15,4,22],[14,3,15,10],[17,3,18,10],[20,3,21,10],[27,2,28,9],[23,3,23,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"… la hoja de cálculo es un instrumento extremadamente potente pero podemos cometer errores en su diseño\"…………….. Consejo: Audite continuamente sus hojas…"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consejos de navegacion a tráves de los vínculos del libro"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volver al vínculo anterior",null,"ALT + ←","ALT+FLECHA IZQUIERDA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volver al vínculo siguiente",null,"ALT + →","ALT+FLECHA DERECHA"]
[]
[null,"Indice General",null,null,null,null,null,null,null,null,null,null,null,null,"R","Restaura valores orginiales"]
[null,null,"Bases del Cuadro de Mando "]
[null,null,null,"Aspectos conceptuales previos, costes "]
[]
[null,null,"Radiografía del Gasto"]
[null,null,null,"Ajuste, analisis, evaluación y localización de los gastos y costes del periodo estimados"]
[]
[null,null,"Actividad Estimada en el Periodo"]
[null,null,null,"Estimación de la produccion y ventas previstas en el periodo vinculada con los gastos del ejericicio. Estimacion de los precios medios de venta y del Mix de Ventas del Periodo"]
[]
[null,null,"Transformación de Gastos en Costes, Gasto vs. Coste"]
[null,null,null,"Asignación de los gastos a costes del producto y del perido. Tasa de repercusion de los costes del periodo por unidad de costes de los productos vendidos"]
[]
[null,null,"Cuadro de Mando de la Producción del Periodo"]
[null,null,null,"Coste de la producción del periodo y análisis de sensibilidad"]
[null,null,"Cuadro de Mando, Ventas y Costes de Estructura del Periodo"]
[]
[null,"Parámetros de configuración general"]
[null,null,"Selección de tipos de vino y envases en el proceso de producción y comercialización. Establecimiento de precios estándar de uva comprada y/o producida. Precios promedio unitarios de venta, etc."]

{"sheet":"Esquema","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[32,9,32,15]]}

{"sheet":"Radiografia del gasto","index":2,"n_rows":52,"n_cols":40,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,18,0,23],[0,33,0,36],[3,26,5,26],[41,34,42,36],[41,37,42,37],[40,34,40,38],[2,38,2,39],[3,33,3,39],[33,35,33,38],[11,35,11,39],[19,35,19,39],[26,35,26,38],[18,35,18,38],[10,35,10,38],[38,34,38,36],[15,30,15,32],[24,25,24,26],[3,25,4,25],[9,18,11,18],[19,22,20,22],[19,23,20,23],[9,19,11,21],[15,19,15,21],[12,19,12,21],[13,19,13,21],[14,19,14,21],[19,24,20,24],[19,25,20,25],[3,24,4,24],[6,18,6,21],[7,18,7,21],[3,18,4,21],[31,19,31,21],[16,19,16,21],[21,18,21,21],[22,18,22,21],[19,18,20,21],[25,19,25,21],[17,19,17,21],[27,19,28,21],[4,3,4,4],[6,17,7,17],[3,23,4,23],[1,1,1,10],[2,1,2,2],[2,3,2,4],[2,5,2,9],[2,10,5,10],[3,5,3,8],[3,9,5,9],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[3,22,4,22],[3,17,4,17],[5,18,5,21],[19,17,20,17],[6,0,14,0],[6,1,14,1],[6,3,6,4],[6,5,6,7],[6,8,6,10],[15,0,24,0],[15,1,24,1],[15,3,15,4],[15,5,15,7],[15,8,15,10],[25,0,28,0],[25,1,28,1],[25,3,25,4],[25,5,25,7],[25,8,25,10],[29,0,34,0],[29,1,34,1],[29,3,29,4],[29,5,29,7],[29,8,29,10],[41,0,46,0],[41,1,46,1],[41,3,41,4],[41,5,41,7],[41,8,41,10],[35,0,39,0],[35,1,39,1],[35,3,35,4],[35,5,35,7],[35,8,35,9],[38,18,38,24],[50,1,50,2],[50,3,50,4],[51,3,51,4],[50,8,50,9],[49,3,49,4],[50,5,51,7]]}
[null,null,"Método formal o contable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Método “ojo de buen cubero”",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conciliación Método Contable - \"Ojo de buen cubero\""]
[null,"Radiografía del Gasto. Análisis, ajuste y asignación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actividad y Costes Estimados del Periodo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ajustes, Gastos vs. Costes"]
[null,"Nota 1:",null,"Gasto real/estimado",null,"Estimación de Coste (Relevancia)",null,null,null,null,"Comprobación (Cheking) en Asignación",null,null,null,null,null,null,null,"Costes Industriales Imputados a la Producción del Periodo  (COSTE DE LA AÑADA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes Industriales del Periodo Imputados:",null,null,null,null,{"$f":"Z39","v":231450.01}]
[null,null,null,null,null,"Departamentos o centros",null,null,null,"Gasto Plurianual y Ajustes",null,null,null,null,null,null,null,null,"Vinos a producir en el periodo",null,null,null,{"$f":"Configuracion!B13","v":"Joven Blanco Semiseco"},{"$f":"Configuracion!C13","v":"Tinto Crianza"},{"$f":"Configuracion!D13","v":"Tinto Barrica"},{"$f":"Configuracion!E13","v":"Tinto Reserva"},"Total",null,null,null,null,null,null,"(Costes del Producto, costes variables)"]
[null,null,null,"2015/2016",null,{"$f":"Configuracion!B7","v":"Finca o Cultivo"},{"$f":"Configuracion!C7","v":"Bodega o Industrial"},{"$f":"Configuracion!D7","v":"Comercial y Logistica"},{"$f":"Configuracion!E7","v":"Administ. Estructura"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gasto Contable Industrial del Periodo"]
[null,"Conceptos /Detalles",null,"Monetario"," %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Envase tipo",null,null,null,{"$f":"Configuracion!B15","v":"Bag in Box"},{"$f":"Configuracion!C15","v":"Bot 3/4"},{"$f":"Configuracion!D15","v":"Bot 3/4"},{"$f":"Configuracion!E15","v":"Bot 3/4"},null,null,null,null,null,null,null,null,"Gastos de Explotación de Cultivo ",null,null,{"$f":"F41","v":206917},"S"]
["N2","60-61Consumos","Total contable:",184562,null,"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D7-D15>0,\"Faltan \"&D7-D15,IF(D7-D15<0,\"Exceso \"&D7-D15,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,"Litros:",null,null,null,13952,30552,22735,8601,{"$f":"SUM(W7:Z7)","v":75840},null,null,null,null,null,null,null,{"$f":"\"(Dpto/Centro: \"&F5&\")\"","v":"(Dpto/Centro: Finca o Cultivo)"}]
[null,null,"Uvas compras",144500,{"$f":"D8/D41","v":0.24194020979313693},144500,0,null,null,null,{"$f":"IF(D8-SUM(F8:J8)>0,\"Faltan \"&D8-SUM(F8:J8),IF(D8-SUM(F8:J8)<0,\"Exceso \"&D8-SUM(F8:J8),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Total Unidades",null,null,null,2791,40737,30314,11468,{"$f":"SUM(W8:Z8)","v":85310},null,null,null,null,null,null,null,"Gastos de Explotación de Bodegas",null,null,{"$f":"G41","v":136933},"S"]
[null,null,"Botellas, corchos, etc.",5584,{"$f":"D9/D41","v":9.3494403562967236E-3},null,5584,null,null,null,{"$f":"IF(D9-SUM(F9:J9)>0,\"Faltan \"&D9-SUM(F9:J9),IF(D9-SUM(F9:J9)<0,\"Exceso \"&D9-SUM(F9:J9),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Coste Industrial  Estimado de la Producción (Coste Variable)",null,null,null,null,null,null,null,{"$f":"SUM(W10:Z10)","v":110000},null,null,null,null,null,null,null,{"$f":"\"(Dpto/Centro: \"&G5&\")\"","v":"(Dpto/Centro: Bodega o Industrial)"}]
[null,null,"Etiquetas y similares",1353,{"$f":"D10/D41","v":2.26536404048522E-3},null,1353,null,null,null,"Correcto",null,null,null,null,null,null,null,"N1","Coste de la UVA:",null,null,15000,25000,40000,30000,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(AL6+AL8)","v":343850}]
[null,null,"Fertizantes, abonos, etc",1850,{"$f":"D11/D41","v":3.0975044160367012E-3},1850,null,null,null,null,"Correcto",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Configuracion!B50","v":0.9},{"$f":"Configuracion!C50","v":1.2},{"$f":"Configuracion!D50","v":1.7},{"$f":"Configuracion!E50","v":1.1000000000000001},null,null,null,null,null,null,null,null,"(1)","Gasto Contable Industrial vs Coste Industrial Imputado:",null,null,null,{"$f":"IF(SUMIF(AM6:AM8,\"S\",AL6:AL8)-AM3<0,0,SUMIF(AM6:AM8,\"S\",AL6:AL8)-AM3)","v":112399.98999999999}]
[null,null,"Productos enológicos",9600,{"$f":"D12/D41","v":1.6073536429163423E-2},null,9600,null,null,null,"Correcto",null,null,null,null,null,null,null,null,null,null,null,{"$f":"W11*W10","v":13500},{"$f":"X11*X10","v":30000},68000,33000,{"$f":"SUM(W12:Z12)","v":144500},null,null,null,null,null,null,null,null,"(Ajuste Incremento del Coste Fijo del Periodo)"]
[null,null,"Tratamientos, etc",425,{"$f":"D13/D41","v":7.1158885233275568E-4},425,null,null,null,null,"Correcto",null,null,null,null,null,null,null,"N2","Proceso Vendimia:",null,null,3300,6700,3300,2200,{"$f":"SUM(W13:Z13)","v":15500},null,null,null,null,null,null,"Gasto Contable de Explotación"]
[null,null,"Otros",21250,{"$f":"D14/D41","v":3.5579442616637785E-2},2500,150,15400,1500,1700,"Correcto",null,null,null,null,null,null,null,"N3","Proceso Previnificación:",null,null,2040,2058,2780,2423,{"$f":"SUM(W14:Z14)","v":9301},null,null,null,null,null,null,null,"Gastos de Distribución",null,null,{"$f":"H41","v":142219},"S"]
[null,null,"Asignado:",{"$f":"SUM(D8:D14)","v":184562},{"$f":"D15/D41","v":0.30901708650408954},{"$f":"SUM(F8:F14)","v":149275},{"$f":"SUM(G8:G14)","v":16687},{"$f":"SUM(H8:H14)","v":15400},{"$f":"SUM(I8:I14)","v":1500},{"$f":"SUM(J8:J14)","v":1700},null,null,null,null,null,null,null,null,"N4","Proceso Vinificación Final:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"(Dpto/Centro: \"&H5&\" )\"","v":"(Dpto/Centro: Comercial y Logistica )"}]
["N3","62 Servicios Externos","Total contable:",80690,null,"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D16-D25>0,\"Faltan \"&D16-D25,IF(D16-D25<0,\"Exceso \"&D16-D25,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,"Coste del vestido:",null,null,2.3000000000000003,0.72,0,1.03,{"$f":"SUMPRODUCT(W16:Z16,W8:Z8)","v":47561.98},null,null,null,null,null,null,null,"Gastos de Administración",null,null,{"$f":"I41","v":93447},"S"]
[null,null,"Arrendamientos",1300,{"$f":"D17/D41","v":2.1766247247825467E-3},1300,null,null,null,null,{"$f":"IF(D17-SUM(F17:J17)>0,\"Faltan \"&D17-SUM(F17:J17),IF(D17-SUM(F17:J17)<0,\"Exceso \"&D17-SUM(F17:J17),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,"Coste de las actividades:",null,null,924,1925,3924,684,{"$f":"SUM(W17:Z17)","v":7457},null,null,null,null,null,null,null,{"$f":"\"(Dpto/Centro: \"&I5&\" )\"","v":"(Dpto/Centro: Administ. Estructura )"}]
[null,null,"Reparaciones",2700,{"$f":"D18/D41","v":4.5206821207022128E-3},150,280,425,150,1695,{"$f":"IF(D18-SUM(F18:J18)>0,\"Faltan \"&D18-SUM(F18:J18),IF(D18-SUM(F18:J18)<0,\"Exceso \"&D18-SUM(F18:J18),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,"Coste de la producción:",null,null,{"$f":"((W17+W14+W13+W12)/W8)+W16","v":9.3813328556073099},{"$f":"((X17+X14+X13+X12)/X8)+X16","v":1.7186744237425438},{"$f":"((Y17+Y14+Y13+Y12)/Y8)+Y16","v":2.5732005014184867},{"$f":"((Z17+Z14+Z13+Z12)/Z8)+Z16","v":4.3703383327520058},null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(AL14+AL16)","v":235666}]
[null,null,"Servic. Profe.Indep",18420,{"$f":"D19/D41","v":3.0841098023457317E-2},6850,8540,null,3030,null,"Correcto",null,null,null,null,null,null,null,"Costes Industriales Imputados a las Ventas del Periodo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(2)","Costes de Estuctura I:",null,null,null,{"$f":"SUMIF(AM14:AM16,\"S\",AL14:AL17)","v":235666}]
[null,null,"Transportes",25650,{"$f":"D20/D41","v":4.2946480146671018E-2},null,null,25650,null,null,"Correcto",null,null,null,null,null,null,null,"Vinos a comercializar en el periodo",null,null,null,{"$f":"Configuracion!B19","v":"Joven Blanco Semiseco"},{"$f":"Configuracion!C19","v":"Tinto Crianza X-1"},{"$f":"Configuracion!D19","v":"Tinto Barrica X-1"},{"$f":"Configuracion!E19","v":"Tinto Reserva X-3"},null,null,null,null,null,null,null,null,null,"(Ajuste Incremento del Coste Fijo del Periodo)"]
[null,null,"Servicios Bancarios",2820,{"$f":"D21/D41","v":4.7216013260667558E-3},null,null,null,2820,null,"Correcto",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otros Gastos Contables: Financieros y Otros"]
[null,null,"Publicidad y Rel. Publ",18750,{"$f":"D22/D41","v":3.1393625838209809E-2},null,null,10250,2500,6000,"Correcto",null,null,null,null,null,null,null,"Envase tipo",null,null,null,{"$f":"Configuracion!B21","v":"Bag in Box"},{"$f":"Configuracion!C21","v":"Bot 3/4"},{"$f":"Configuracion!D21","v":"Bot 3/4"},{"$f":"Configuracion!E21","v":"Bot 3/4"},null,null,null,null,null,null,null,null,"Gastos financieros y similares",null,null,{"$f":"SUM(F43:I43)","v":1500},"S"]
[null,null,"Sumini. y Comunica.",6250,{"$f":"D23/D41","v":1.0464541946069937E-2},null,null,3580,2670,null,"Correcto",null,null,null,null,null,null,null,"Total Unidades",null,null,null,2791,35750,25215,11468,{"$f":"SUM(W23:Z23)","v":75224},null,null,null,null,null,null,null,"Pérdidas Extraordinarias",null,null,{"$f":"SUM(F44:I44)","v":0},"S"]
[null,null,"Otros Servicios",4800,{"$f":"D24/D41","v":8.0367682145817115E-3},null,null,null,4800,null,"Correcto",null,null,null,null,null,null,null,null,null,null,"Mix de Ventas",{"$f":"W23/$AA$23","v":3.7102520472189725E-2},{"$f":"X23/$AA$23","v":0.4752472615122833},{"$f":"Y23/$AA$23","v":0.33519887270020204},{"$f":"Z23/$AA$23","v":0.15245134531532489},null,null,null,null,null,null,null,null,"Otras Dotaciones",null,null,{"$f":"SUM(F45:I45)","v":0},"S"]
[null,null,"Asignado:",{"$f":"SUM(D17:D24)","v":80690},{"$f":"D25/D41","v":0.13510142234054132},{"$f":"SUM(F17:F24)","v":8300},{"$f":"SUM(G17:G24)","v":8820},{"$f":"SUM(H17:H24)","v":39905},{"$f":"SUM(I17:I24)","v":15970},{"$f":"SUM(J17:J24)","v":7695},null,null,null,null,null,null,null,null,"Coste Industrial  Estimado de las Ventas (Coste Variable)",null,null,null,null,null,null,{"$f":"SUM(W27:Z27)+AA29","v":209717.32},null,null,null,null,null,null,null,null,"Otros",null,null,{"$f":"SUM(F46:I46)","v":0},"S"]
["N4","63 Impuestos","Total contable:",4400,{"$f":"D26/D41","v":7.3670375300332351E-3},"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D26-D29>0,\"Faltan \"&D26-D29,IF(D26-D29<0,\"Exceso \"&D26-D29,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,"N5","Coste Acumulado Heredado",null,null,9.3800000000000008,1.72,2.57,4.37,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(AL22:AL25)","v":1500}]
[null,null,"De explotación",2600,{"$f":"D27/D41","v":4.3532494495650935E-3},150,2450,null,null,null,{"$f":"IF(D27-SUM(F27:J27)>0,\"Faltan \"&D27-SUM(F27:J27),IF(D27-SUM(F27:J27)<0,\"Exceso \"&D27-SUM(F27:J27),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W26*W23","v":26179.58},{"$f":"X26*X23","v":61490},{"$f":"Y26*Y23","v":64802.549999999996},{"$f":"Z26*Z23","v":50115.16},null,null,null,null,null,null,null,null,"(3)","Costes de Estuctura II:",null,null,null,{"$f":"SUMIF(AM21:AM23,\"S\",AL21:AL24)","v":1500}]
[null,null,"Otros",1800,{"$f":"D28/D41","v":3.0137880804681416E-3},null,null,null,1800,null,{"$f":"IF(D28-SUM(F28:J28)>0,\"Faltan \"&D28-SUM(F28:J28),IF(D28-SUM(F28:J28)<0,\"Exceso \"&D28-SUM(F28:J28),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"N6","Coste Industrial del Periodo Imputado a Otras Añadas",null,null,0,0,0.21,0.16,null,null,null,null,null,null,null,"Coste de Oportunidad"]
[null,null,"Asignado:",{"$f":"SUM(D27:D28)","v":4400},{"$f":"D29/D41","v":7.3670375300332351E-3},{"$f":"F27+F28","v":150},{"$f":"G27+G28","v":2450},{"$f":"H27+H28","v":0},{"$f":"I27+I28","v":1800},{"$f":"J27+J28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W28*W23","v":0},{"$f":"X28*X23","v":0},{"$f":"Y28*Y23","v":5295.15},{"$f":"Z28*Z23","v":1834.88},{"$f":"SUM(W29:Z29)","v":7130.03},null,null,null,null,null,null,null,"Dpto",{"$f":"F5","v":"Finca o Cultivo"},null,{"$f":"F50","v":250},"N"]
["N5","64 Personal","Total contable:",318703,{"$f":"D30/D41","v":0.53361294589413233},"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D30-D35>0,\"Faltan \"&D30-D35,IF(D30-D35<0,\"Exceso \"&D30-D35,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W26+W28","v":9.3800000000000008},{"$f":"X26+X28","v":1.72},2.78,4.53,null,null,null,null,null,null,null,null,"Dpto",{"$f":"G5","v":"Bodega o Industrial"},null,{"$f":"G50","v":6804},"N"]
[null,null,"Sueldos y Salarios",225410,{"$f":"D31/D41","v":0.37740998401017989},35450,75860,60580,53520,null,{"$f":"IF(D31-SUM(F31:J31)>0,\"Faltan \"&D31-SUM(F31:J31),IF(D31-SUM(F31:J31)<0,\"Exceso \"&D31-SUM(F31:J31),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Precios Promedios Ponderados Unitarios de las ventas del periodo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dpto",{"$f":"H5","v":"Comercial y Logistica"},null,{"$f":"H50","v":1500},"S"]
[null,null,"Seguridad Social empresa",78893,{"$f":"D32/D41","v":0.13209265724020727},12407,26551,21203,18732,null,{"$f":"IF(D32-SUM(F32:J32)>0,\"Faltan \"&D32-SUM(F32:J32),IF(D32-SUM(F32:J32)<0,\"Exceso \"&D32-SUM(F32:J32),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"N7","Precio medio ponderado",null,null,{"$f":"Configuracion!B27","v":25},{"$f":"Configuracion!C27","v":6.18},{"$f":"Configuracion!D27","v":15.25},{"$f":"Configuracion!E27","v":18.45},{"$f":"SUMPRODUCT(W32:Z32,W24:Z24)","v":11.789101217696478},null,null,null,null,null,null,null,"Dpto",{"$f":"I5","v":"Administ. Estructura"},null,{"$f":"I50","v":110},"S"]
[null,null,"Indemnizaciones",7000,{"$f":"D33/D41","v":1.1720286979598329E-2},null,null,null,null,7000,{"$f":"IF(D33-SUM(F33:J33)>0,\"Faltan \"&D33-SUM(F33:J33),IF(D33-SUM(F33:J33)<0,\"Exceso \"&D33-SUM(F33:J33),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(AL29:AL32)","v":8664}]
[null,null,"Otras Gtos Sociales",7400,{"$f":"D34/D41","v":1.2390017664146805E-2},560,1695,3151,850,1144,{"$f":"IF(D34-SUM(F34:J34)>0,\"Faltan \"&D34-SUM(F34:J34),IF(D34-SUM(F34:J34)<0,\"Exceso \"&D34-SUM(F34:J34),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(4)","Costes de Estuctura y III:",null,null,null,{"$f":"SUMIF(AM29:AM32,\"S\",AL29:AL32)","v":1610}]
[null,null,"Asignado:",{"$f":"SUM(D31:D34)","v":318703},{"$f":"D35/D41","v":0.53361294589413233},{"$f":"F31+F32+F33+F34","v":48417},{"$f":"G31+G32+G33+G34","v":104106},{"$f":"H31+H32+H33+H34","v":84934},{"$f":"I31+I32+I33+I34","v":73102},{"$f":"J31+J32+J33+J34","v":8144}]
["N6","68 Amortización","Total contable:",8900,null,"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D36-D40>0,\"Faltan \"&D36-D40,IF(D36-D40<0,\"Exceso \"&D36-D40,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,"Resumen Coste Industrial del Periodo Imputado",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resumen Costes del Producto y del Periodo "]
[null,null,"Física/Técnica",3200,{"$f":"D37/D41","v":5.3578454763878076E-3},525,620,1230,825,null,{"$f":"IF(D37-SUM(F37:J37)>0,\"Faltan \"&D37-SUM(F37:J37),IF(D37-SUM(F37:J37)<0,\"Exceso \"&D37-SUM(F37:J37),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Costes Industriales Producción del Periodo  (COSTE DE LA AÑADA)",null,null,null,null,null,null,{"$f":"AA12+AA13+AA14+AA16+AA17","v":224319.98},{"$f":"Z37/Z39","v":0.96919408212598479},null,null,null,null,null,null,null,"Coste Imputado al Producto (Coste Variable)",null,null,{"$f":"AM3","v":231450.01},{"$f":"AL37/AL39","v":0.39725314352603558}]
[null,null,"Funcional",5500,{"$f":"D38/D41","v":9.2087969125415441E-3},250,4250,750,250,null,{"$f":"IF(D38-SUM(F38:J38)>0,\"Faltan \"&D38-SUM(F38:J38),IF(D38-SUM(F38:J38)<0,\"Exceso \"&D38-SUM(F38:J38),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Coste Industrial del Periodo Imputado a Otras Añadas",null,null,null,null,null,null,{"$f":"AA29","v":7130.03},{"$f":"Z38/Z39","v":3.0805917874015213E-2},null,null,null,null,null,null,null,"Costes de Estructura (Coste Fijo) (1+2+3+4)",null,null,{"$f":"AN11+AN19+AN27+AN34","v":351175.99},{"$f":"AL38/AL39","v":0.60274685647396442}]
[null,null,"Otras",200,{"$f":"D39/D41","v":3.3486534227423798E-4},null,null,null,null,200,{"$f":"IF(D39-SUM(F39:J39)>0,\"Faltan \"&D39-SUM(F39:J39),IF(D39-SUM(F39:J39)<0,\"Exceso \"&D39-SUM(F39:J39),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,"Costes Industriales del Periodo Imputados a los Productos:",null,null,null,null,null,null,{"$f":"SUM(Z37:Z38)","v":231450.01},{"$f":"SUM(AA37:AA38)","v":1},null,null,null,null,null,null,null,"Coste Total del Periodo",null,null,{"$f":"SUM(AL37:AL38)","v":582626},{"$f":"SUM(AM37:AM38)","v":1}]
[null,null,"Asignado:",{"$f":"SUM(D37:D39)","v":8900},{"$f":"D40/D41","v":1.490150773120359E-2},{"$f":"F37+F38+F39","v":775},{"$f":"G37+G38+G39","v":4870},{"$f":"H37+H38+H39","v":1980},{"$f":"I37+I38+I39","v":1075},{"$f":"J37+J38+J39","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste  Total  de los Productos Vendidos",null,null,{"$f":"SUM(W27:Z27)+AA29","v":209717.32}]
[null,"Total Gtos Explotación",null,{"$f":"D40+D35+D29+D25+D15","v":597255},{"$f":"D41/D41","v":1},{"$f":"F40+F35+F29+F25+F15","v":206917},{"$f":"G40+G35+G29+G25+G15","v":136933},{"$f":"H40+H35+H29+H25+H15","v":142219},{"$f":"I40+I35+I29+I25+I15","v":93447},{"$f":"J40+J35+J29+J25+J15","v":17739},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"_____________________________________________"]
["N7","Otros Gtos/Costes","Total contable:",7930,null,"Comprobación (Cheking) Total:",null,null,{"$f":"IF(D42-D47>0,\"Faltan \"&D42-D47,IF(D42-D47<0,\"Exceso \"&D42-D47,\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasa de imputación de costes fijos del periodo por unidad de coste de producto vendido",null,null,{"$f":"AL38/AL40","v":1.6745206833655895}]
[null,null,"65-66 Gtos Finan. Y simil",1500,{"$f":"D43/$D$48","v":0.18915510718789408},null,null,null,1500,null,{"$f":"IF(D43-SUM(F43:J43)>0,\"Faltan \"&D43-SUM(F43:J43),IF(D43-SUM(F43:J43)<0,\"Exceso \"&D43-SUM(F43:J43),\"Correcto\"))","v":"Correcto"}]
[null,null,"67 Pérdidas Extraord.",4750,{"$f":"D44/$D$48","v":0.59899117276166458},null,null,null,null,4750,{"$f":"IF(D44-SUM(F44:J44)>0,\"Faltan \"&D44-SUM(F44:J44),IF(D44-SUM(F44:J44)<0,\"Exceso \"&D44-SUM(F44:J44),\"Correcto\"))","v":"Correcto"}]
[null,null,"69 Otras Dotaciones",1580,{"$f":"D45/$D$48","v":0.19924337957124844},null,null,0,null,1580,{"$f":"IF(D45-SUM(F45:J45)>0,\"Faltan \"&D45-SUM(F45:J45),IF(D45-SUM(F45:J45)<0,\"Exceso \"&D45-SUM(F45:J45),\"Correcto\"))","v":"Correcto"}]
[null,null,"Otros",100,{"$f":"D46/$D$48","v":1.2610340479192938E-2},null,null,null,null,100,{"$f":"IF(D46-SUM(F46:J46)>0,\"Faltan \"&D46-SUM(F46:J46),IF(D46-SUM(F46:J46)<0,\"Exceso \"&D46-SUM(F46:J46),\"Correcto\"))","v":"Correcto"}]
[null,null,"Asignado:",{"$f":"SUM(D43:D46)","v":7930},{"$f":"D47/D48","v":1},{"$f":"F43+F44+F45+F46","v":0},{"$f":"G43+G44+G45+G46","v":0},{"$f":"H43+H44+H45+H46","v":0},{"$f":"I43+I44+I45+I46","v":1500},{"$f":"J43+J44+J45+J46","v":6430}]
[null,"Total Otros Gastos",null,{"$f":"D47","v":7930},{"$f":"D48/D48","v":1},{"$f":"F47","v":0},{"$f":"G47","v":0},{"$f":"H47","v":0},{"$f":"I47","v":1500},{"$f":"J47","v":6430}]
[]
["N8","Coste de Oportunidad:",null,{"$f":"SUM(F50:J50)","v":8664},null,250,6804,1500,110]
[null,"TOTAL GASTOS:",null,{"$f":"D50+D48+D41","v":613849},null,"Costes Imputables al producto y al periodo",null,null,{"$f":"D51-D52","v":589680}]
[null,null," - Plurianuales y ajustes:",{"$f":"J41+J48","v":24169}]

{"sheet":"CM_Produccion","index":3,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,2,27,3],[3,11,3,12],[8,4,9,4],[8,6,9,6],[8,8,9,8],[8,10,9,10],[8,12,9,12],[25,1,25,3],[17,1,17,3],[19,1,20,8],[18,2,18,3],[5,1,6,12],[1,9,1,10],[2,9,2,10],[3,9,3,10],[1,1,1,3],[2,1,2,3],[3,1,3,3]]}
[null,null,"PRODUCCION: Cuadro de Mando y Análisis de Sensibilidad "]
[null,"Total Gastos Contables:",null,null,{"$f":"'Radiografia del gasto'!D51","v":613849},null,"Coste imputado al producto:",null,null,{"$f":"'Radiografia del gasto'!AL37","v":231450.01}]
[null," - Gastos Plurianuales:",null,null,{"$f":"'Radiografia del gasto'!D52","v":24169},null,"Coste imputados al periodo:",null,null,{"$f":"'Radiografia del gasto'!AL38","v":351175.99}]
[null," = Gastos del Periodo:",null,null,{"$f":"'Radiografia del gasto'!I51","v":589680},null,"Total Costes Imputados:",null,null,{"$f":"'Radiografia del gasto'!AL39","v":582626},null,{"$f":"J4/E4","v":0.98803757970424633}]
[]
[null,"Estimación de los Costes de Producción del Periodo (COSTE DE LA AÑADA)"]
[]
[]
[null,null,null,null,{"$f":"'Radiografia del gasto'!W4","v":"Joven Blanco Semiseco"},null,{"$f":"'Radiografia del gasto'!X4","v":"Tinto Crianza"},null,{"$f":"'Radiografia del gasto'!Y4","v":"Tinto Barrica"},null,{"$f":"'Radiografia del gasto'!Z4","v":"Tinto Reserva"},null,"TOTAL"]
[]
[null,null,null,null,{"$f":"'Radiografia del gasto'!W6","v":"Bag in Box"},null,{"$f":"'Radiografia del gasto'!X6","v":"Bot 3/4"},null,{"$f":"'Radiografia del gasto'!Y6","v":"Bot 3/4"},null,{"$f":"'Radiografia del gasto'!Z6","v":"Bot 3/4"}]
[null,"Unidades:",null,null,{"$f":"'Radiografia del gasto'!W8","v":2791},null,{"$f":"'Radiografia del gasto'!X8","v":40737},null,{"$f":"'Radiografia del gasto'!Y8","v":30314},null,11468,null,{"$f":"SUM(E12+G12+I12+K12)","v":85310}]
[null,"Mix de Producción:",null,null,{"$f":"E12/$M$12","v":3.2715977024967764E-2},null,{"$f":"G12/$M$12","v":0.47751728988395264},null,{"$f":"I12/$M$12","v":0.35533935060368071},null,{"$f":"K12/$M$12","v":0.13442738248739891},null,{"$f":"SUM(E13+G13+I13+K13)","v":1}]
[null,"Coste Industrial  Estimado de la Producción (Coste Variable)"]
[null,"Coste de la Uva:",null,null,{"$f":"'Radiografia del gasto'!W11","v":0.9},null,{"$f":"'Radiografia del gasto'!X11","v":1.2},null,{"$f":"'Radiografia del gasto'!Y11","v":1.7},null,{"$f":"'Radiografia del gasto'!Z11","v":1.1000000000000001}]
[null,null,null,null,{"$f":"'Radiografia del gasto'!W12/'Radiografia del gasto'!W8","v":4.8369759942672879},{"$f":"E16/E18","v":0.51559581870887161},{"$f":"'Radiografia del gasto'!X12/'Radiografia del gasto'!X8","v":0.73643125414242583},{"$f":"G16/G18","v":0.42848793463673646},{"$f":"'Radiografia del gasto'!Y12/'Radiografia del gasto'!Y8","v":2.2431879659563236},{"$f":"I16/I18","v":0.87175016665812011},{"$f":"'Radiografia del gasto'!Z12/'Radiografia del gasto'!Z8","v":2.8775723753051969},{"$f":"K16/K18","v":0.65843240413224191},{"$f":"((K16*$K$13)+(I16*$I$13)+(G16*$G$13)+(E16*$E$13))","v":1.693822529597937},{"$f":"M16/M18","v":0.64416910165559027}]
[null,"Coste Industrial Imputado:",null,null,{"$f":"(('Radiografia del gasto'!W13+'Radiografia del gasto'!W14+'Radiografia del gasto'!W17)/'Radiografia del gasto'!W8)+'Radiografia del gasto'!W16","v":4.544356861340022},{"$f":"E17/E18","v":0.48440418129112833},{"$f":"(('Radiografia del gasto'!X13+'Radiografia del gasto'!X14+'Radiografia del gasto'!X17)/'Radiografia del gasto'!X8)+'Radiografia del gasto'!X16","v":0.98224316960011782},{"$f":"G17/G18","v":0.57151206536326349},{"$f":"(('Radiografia del gasto'!Y13+'Radiografia del gasto'!Y14+'Radiografia del gasto'!Y17)/'Radiografia del gasto'!Y8)+'Radiografia del gasto'!Y16","v":0.33001253546216269},{"$f":"I17/I18","v":0.12824983334187992},{"$f":"(('Radiografia del gasto'!Z13+'Radiografia del gasto'!Z14+'Radiografia del gasto'!Z17)/'Radiografia del gasto'!Z8)+'Radiografia del gasto'!Z16","v":1.4927659574468084},{"$f":"K17/K18","v":0.34156759586775798},{"$f":"((K17*$K$13)+(I17*$I$13)+(G17*$G$13)+(E17*$E$13))","v":0.93564623139139613},{"$f":"M17/M18","v":0.35583089834440956}]
[null,"COSTE TOTAL DEL VINO",null,null,{"$f":"E17+E16","v":9.3813328556073099},null,{"$f":"G17+G16","v":1.7186744237425438},null,{"$f":"I17+I16","v":2.5732005014184862},null,{"$f":"K17+K16","v":4.3703383327520058},null,{"$f":"((K18*$K$13)+(I18*$I$13)+(G18*$G$13)+(E18*$E$13))","v":2.6294687609893335}]
[null,null,{"$f":"(E18*$E$12)+(G18*$G$12)+(I18*$I$12)+(K18*$K$12)","v":224319.98}]
[null,"Simulación - Análisis de Sensibilidad -"]
[]
[null,"Coste de la Uva:",null,null,{"$f":"E23/100","v":0.9},null,{"$f":"G23/100","v":1.2},null,{"$f":"I23/100","v":1.7},null,{"$f":"K23/100","v":1.1000000000000001}]
[null,null,null,"R",{"$f":"E15*100","v":90},null,{"$f":"G15*100","v":120},null,{"$f":"I15*100","v":170},null,{"$f":"K15*100","v":110.00000000000001}]
[null,null,null,"Variación",{"$f":"(E22-E15)","v":0},null,{"$f":"(G22-G15)","v":0},null,{"$f":"(I22-I15)","v":0},null,{"$f":"(K22-K15)","v":0}]
[null,null,null,null,{"$f":"E24/E15","v":0},null,{"$f":"G24/G15","v":0},null,{"$f":"I24/I15","v":0},null,{"$f":"K24/K15","v":0}]
[null,"COSTE TOTAL DEL VINO",null,null,{"$f":"((E22*'Radiografia del gasto'!W10)/'Radiografia del gasto'!W8)+E17","v":9.3813328556073099},null,{"$f":"((G22*'Radiografia del gasto'!X10)/'Radiografia del gasto'!X8)+CM_Produccion!G17","v":1.7186744237425438},null,{"$f":"((I22*'Radiografia del gasto'!Y10)/'Radiografia del gasto'!Y8)+I17","v":2.5732005014184862},null,{"$f":"((K22*'Radiografia del gasto'!Z10)/'Radiografia del gasto'!Z8)+K17","v":4.3703383327520058},null,{"$f":"(K26*$K$13)+(I26*$I$13)+(G26*$G$13)+(E26*$E$13)","v":2.6294687609893335}]
[null,null,null,"Variación",{"$f":"(E26-E18)","v":0},null,{"$f":"(G26-G18)","v":0},null,{"$f":"(I26-I18)","v":0},null,{"$f":"(K26-K18)","v":0},null,{"$f":"(M26-M18)","v":0}]
[null,null,{"$f":"(E26*$E$12)+(G26*$G$12)+(I26*$I$12)+(K26*$K$12)","v":224319.98},null,{"$f":"E27/E18","v":0},null,{"$f":"G27/G18","v":0},null,{"$f":"I27/I18","v":0},null,{"$f":"K27/K18","v":0},null,{"$f":"M27/M18","v":0}]

{"sheet":"CM","index":4,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[[35,14,35,15],[34,9,34,10],[33,9,33,10],[2,1,2,9],[31,9,31,10],[31,1,31,3],[32,1,32,3],[32,9,32,10],[19,9,19,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[14,9,14,10],[17,9,17,10],[28,9,28,10],[29,4,29,7],[4,4,5,5],[29,9,29,10],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,10],[6,9,6,10],[7,9,7,10],[27,1,28,4],[27,9,27,10],[27,7,27,8],[10,9,10,10],[8,9,8,10],[29,14,30,15],[29,16,30,16],[29,18,30,18],[9,9,9,10],[18,16,18,17],[18,18,18,19],[19,14,19,15],[20,14,20,15],[21,14,22,15],[24,16,25,18],[26,14,26,15],[28,16,28,17],[28,18,28,19],[24,14,25,15],[33,14,34,15],[33,16,34,16],[33,18,34,18],[33,20,34,20],[31,20,32,20],[31,14,32,15],[31,16,32,16],[31,18,32,18]]}
[null,"Cuadro de Mando y Análisis de Sensibilidad"]
[]
[null,"Estimación de los ingresos y margenes del periodo - Análisis de Sensibilidad"]
[]
[null,null,null,null,{"$f":"'Radiografia del gasto'!W20","v":"Joven Blanco Semiseco"},null,{"$f":"'Radiografia del gasto'!X20","v":"Tinto Crianza X-1"},{"$f":"'Radiografia del gasto'!Y20","v":"Tinto Barrica X-1"},{"$f":"'Radiografia del gasto'!Z20","v":"Tinto Reserva X-3"},"TOTAL"]
[null,null,null,null,0]
[null,"Unidades:",null,null,{"$f":"'Radiografia del gasto'!W23","v":2791},null,{"$f":"'Radiografia del gasto'!X23","v":35750},{"$f":"'Radiografia del gasto'!Y23","v":25215},{"$f":"'Radiografia del gasto'!Z23","v":11468},{"$f":"SUM(E7:I7)","v":75224}]
[null,"Mix de Ventas:",null,null,{"$f":"E7/$J$7","v":3.7102520472189725E-2},null,{"$f":"G7/$J$7","v":0.4752472615122833},{"$f":"H7/$J$7","v":0.33519887270020204},{"$f":"I7/$J$7","v":0.15245134531532489},{"$f":"SUM(E8:I8)","v":1}]
[null,"Precios Medios:",null,null,{"$f":"'Radiografia del gasto'!W32","v":25},null,{"$f":"'Radiografia del gasto'!X32","v":6.18},{"$f":"'Radiografia del gasto'!Y32","v":15.25},{"$f":"'Radiografia del gasto'!Z32","v":18.45},{"$f":"SUMPRODUCT(E8:I8,E9:I9)","v":11.789101217696478}]
[null,"Coste Variable Unitario",null,null,{"$f":"'Radiografia del gasto'!W30","v":9.3800000000000008},null,{"$f":"'Radiografia del gasto'!X30","v":1.72},{"$f":"'Radiografia del gasto'!Y30","v":2.78},{"$f":"'Radiografia del gasto'!Z30","v":4.53},{"$f":"SUMPRODUCT(E8:I8,E10:I10)","v":2.7879043922152507}]
[null,"Márgenes Unitarios",null,null,{"$f":"E9-E10","v":15.62},null,{"$f":"G9-G10","v":4.46},{"$f":"H9-H10","v":12.47},{"$f":"I9-I10","v":13.919999999999998},{"$f":"J9-J10","v":9.0011968254812267}]
[]
[]
[]
[null,"R","Mix de ventas",null,{"$f":"E16","v":2791},null,{"$f":"G16","v":35750},{"$f":"H16","v":25215},{"$f":"I16","v":11468},{"$f":"SUM(E16:I16)","v":75224}]
[null,null,null,null,{"$f":"E7","v":2791},null,{"$f":"G7","v":35750},{"$f":"H7","v":25215},{"$f":"I7","v":11468}]
[null,null,null,null,{"$f":"E15/$J$15","v":3.7102520472189725E-2},null,{"$f":"G15/$J$15","v":0.4752472615122833},0.33519887270020204,0.15245134531532489,null,{"$f":"SUM(E17:I17)","v":1}]
[null,null,null,"Variación",{"$f":"E15-E7","v":0},null,{"$f":"G15-G7","v":0},{"$f":"H15-H7","v":0},{"$f":"I15-I7","v":0},{"$f":"SUM(E18:I18)","v":0},null,null,null,null,"RESULTADOS DEL PERIODO PREVISTOS:"]
[null,null,null,null,{"$f":"IFERROR(E18/E7,0)","v":0},null,{"$f":"IFERROR(G18/G7,0)","v":0},{"$f":"IFERROR(H18/H7,0)","v":0},{"$f":"IFERROR(I18/I7,0)","v":0},null,{"$f":"IFERROR(K18/K7,0)","v":0},null,null,null,null,null,"ESTIMADO",null,"SENSIBILIDAD",null,"Variación"]
[null,"R","Precios Medios",null,{"$f":"ROUND(E21/100,2)","v":25},null,{"$f":"ROUND(G21/100,2)","v":6.18},{"$f":"ROUND(H21/100,2)","v":15.25},{"$f":"ROUND(I21/100,2)","v":18.45},{"$f":"(SUMPRODUCT(E20:I20,E17:I17))","v":11.789101217696478},null,null,null,null,"Actividad prevista",null,{"$f":"J7","v":75224},null,{"$f":"J15","v":75224},null,{"$f":"(S20-Q20)","v":0},{"$f":"IFERROR((S20-Q20)/Q20,0)","v":0}]
[null,null,null,null,{"$f":"E9*100","v":2500},null,{"$f":"G9*100","v":618},{"$f":"H9*100","v":1525},{"$f":"I9*100","v":1845},null,null,null,null,null,"Ingresos previtos",null,{"$f":"Q20*J9","v":886823.34999999986},null,{"$f":"S20*J20","v":886823.34999999986},null,{"$f":"(S21-Q21)","v":0},{"$f":"IFERROR((S21-Q21)/Q21,0)","v":0}]
[null,null,null,"Variación",{"$f":"E20-E9","v":0},null,{"$f":"G20-G9","v":0},{"$f":"H20-H9","v":0},{"$f":"I20-I9","v":0},{"$f":"K20-K9","v":0},null,null,null,null," - Coste de Ventas  (Coste Variable Industrial)",null,{"$f":"J10","v":2.7879043922152507},null,{"$f":"J20-J24","v":2.787904392215248}]
[null,null,null,null,{"$f":"IFERROR(E22/E9,0)","v":0},null,{"$f":"IFERROR(G22/G9,0)","v":0},{"$f":"IFERROR(H22/H9,0)","v":0},{"$f":"IFERROR(I22/I9,0)","v":0},{"$f":"IFERROR(J22/K9,0)","v":0},null,null,null,null,null,null,{"$f":"Q22*Q20","v":209717.32},null,{"$f":"S22*S20","v":209717.3199999998},null,-2.0372681319713593E-10,{"$f":"IFERROR((S23-Q23)/Q23,0)","v":-9.7143532635805158E-16}]
[null,"Márgenes Unitarios",null,null,{"$f":"E20-E10","v":15.62},null,{"$f":"G20-G10","v":4.46},{"$f":"H20-H10","v":12.47},{"$f":"I20-I10","v":13.919999999999998},{"$f":"SUMPRODUCT(E24:I24,E17:I17)","v":9.0011968254812302},null,null,null,null," = Margen Contribución Bruto",null,{"$f":"ROUND(Q21-Q23,1)","v":677106},{"$f":"Q24/Q21","v":0.76351846170942628},{"$f":"ROUND(S21-S23,0)","v":677106},{"$f":"S24/S21","v":0.76351846170942628},{"$f":"ROUND((S24-Q24),0)","v":0},{"$f":"IFERROR((S24-Q24)/Q24,0)","v":0}]
[null,null,null,"Variación",{"$f":"E24-E11","v":0},null,{"$f":"G24-G11","v":0},{"$f":"H24-H11","v":0},{"$f":"I24-I11","v":0},null,{"$f":"J24-J11","v":0},null,null,null," - Costes de Estructura (Costes Fijos del Periodo + Bº deseado)",null,{"$f":"G28+J28","v":351175.99}]
[null,null,null,null,{"$f":"IFERROR(E25/E11,0)","v":0},null,{"$f":"IFERROR(G25/G11,0)","v":0},{"$f":"IFERROR(H25/H11,0)","v":0},{"$f":"IFERROR(I25/I11,0)","v":0},null,{"$f":"IFERROR(K25/J11,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," = RESULTADO ANALITICO:",null,{"$f":"Q24-Q25","v":325930.01},{"$f":"Q27/Q21","v":0.36752529125445338},{"$f":"S24-Q25","v":325930.01},{"$f":"S27/S21","v":0.36752529125445338},{"$f":"(S27-Q27)","v":0},{"$f":"IFERROR((S27-Q27)/Q27,0)","v":0}]
[null,"Coste de Estructura (Costes Fijos del Periodo)",null,null,null,null,{"$f":"'Radiografia del gasto'!AL38","v":351175.99},"Beneficio deseado:",null,0]
[null,null,null,null,null,"Punto Muerto Estimado:",null,null,{"$f":"(G28+J28)/J11","v":39014.366290254431},{"$f":"I29*J9","v":459944.31314009492},null,null,null,null,"INDICADORES BASE",null,{"$f":"Q19","v":"ESTIMADO"},null,{"$f":"S19","v":"SENSIBILIDAD"},null,{"$f":"U19","v":"Variación"}]
[null,null,null,null,"Punto Muerto Sensibilidad:",null,null,null,{"$f":"(G28+J28)/J24","v":39014.366290254417},{"$f":"I30*J20","v":459944.31314009475},null,null,null,null,"Nivel de Actividad del pto. muerto",null,{"$f":"I29/Q20","v":0.51864253815609951},null,{"$f":"I30/S20","v":0.51864253815609929}]
[null,"MIX DE VENTAS",null,null,null,null,null,null,{"$f":"ROUND((I30-I29)/I29,2)","v":0},null,{"$f":"ROUND((J30-J29)/J29,2)","v":0}]
[null,"Estimación:",null,null,{"$f":"E8*$I$29","v":1447.5313239936738},null,{"$f":"G8*$I$29","v":18541.470739080556},{"$f":"H8*$I$29","v":13077.571599606048},5947.7926275741493,{"$f":"SUM(E32:I32)","v":39014.366290254424},null,null,null,null,"Resultado Neto generado por unidad vendida",null,{"$f":"Q27/Q20","v":4.3327928586621294},null,{"$f":"S27/S20","v":4.3327928586621294},null,{"$f":"S32-Q32","v":0}]
[null,"Sensibilidad:",null,null,{"$f":"E17*$I$30","v":1447.5313239936731},null,{"$f":"G17*$I$30","v":18541.470739080552},{"$f":"H17*$I$30","v":13077.571599606044},5947.7926275741474,{"$f":"SUM(E33:I33)","v":39014.366290254417}]
[null,null,null,"Variación",{"$f":"E33-E32","v":0},null,{"$f":"G33-G32","v":0},{"$f":"H33-H32","v":0},0,{"$f":"J33-J32","v":0},null,null,null,null,"Resultado Neto generado por €  facturado",null,{"$f":"Q27/Q21","v":0.36752529125445338},null,{"$f":"S27/S21","v":0.36752529125445338},null,{"$f":"S34-Q34","v":0}]
[null,null,null,null,{"$f":"IFERROR(E34/E32,0)","v":0},null,{"$f":"IFERROR(G34/G32,0)","v":0},{"$f":"IFERROR(H34/H32,0)","v":0},0,{"$f":"IFERROR(J34/J32,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasa de costes estructura (*)",null,{"$f":"$Q$25/Q23","v":1.6745206833655895},null,{"$f":"Q25/S23","v":1.674520683365591},null,{"$f":"S36-Q36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(*) Tasa de imputación de costes fijos del periodo por € de coste de producto vendido. Incluye Bº deseado"]

{"sheet":"Notas","index":5,"n_rows":57,"n_cols":20,"rows_kept":57,"cut":false,"hidden":false,"merged":[[9,19,11,24],[14,19,18,24],[56,1,58,6],[3,1,4,6],[8,1,9,6],[10,1,11,6],[14,1,16,6],[53,1,53,6],[54,1,55,6],[36,0,37,5],[36,6,37,6],[26,1,27,6],[28,1,29,6],[21,19,22,24],[7,19,8,24]]}
["Nota 0: Consideraciones generales"]
[null,"En azul son datos para introducir y/o modificar"]
[null,"En negro son datos calculados o estimados. Estan protegidos"]
[null,"Las letras en color rojo intenso contienten hipervinculos a otras celdas o pestañas y que tienen un carácter informativo o aclaratorio"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota 5: Coste Heredado"]
["Nota 1: Coste de la uva en vendimia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para los vinos jovenes el valor a registrar debe coicidir con el de producción del periodo estimado y como coste industrial del periodo tendríamos que poner 0 ya que si no se duplicaría la consideración del coste. "]
[null,"En el caso de mezcla de uva propia y comprada se aconseja considerar el precio medio podenderado de compra y de coste de producción."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para los vinos de añadas anteriores y que  serán comercializados en el presente periodo estos tienen unos costes acumulados correspondientes a ejercicios pasados como son la uva, procesos de vinificación, etc, que debera reflejarse igualmente en este apartado"]
[null,"Se ha estimado una tasa media de rechazo de uva en entrada en bodga del 0,5%"]
[]
[]
["Nota 2: Proceso vendimia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota 6: Coste Industrial del Periodo Imputado a Otras Añadas"]
[null,"A titulo orientativo se propone evaluar economica y financieramento los siguientes componentes del coste del proceso de vendimia y de sus actividades y tareas.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Son costes imputables a los vinos de añadas anteriores pero que aún permanecen en bodega porque se encuentran semiterminados y por tanto falta algún  proceso de vinificación como puede ser envejecimiento, embotellado, vestido, etc y que se realizara en el periodo y por tanto consumen recursos del presente ejercicio económico. En el caso de vinos jóvenes, es decir que se produce y vende en el año, este valor debe ser 0 ya que si no se duplicaría la consideración del coste."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota 7: Precio Medios"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Se establece el precio medio unitario neto, desdcontados los descuentos comerciales, ponderado por canal o tipo de cliente según volumen de facturación"]
[]
[]
["Nota 3: Proceso Previnificación"]
["General:"]
[null,"El promedio del sector considera un 70% aunuqe depende de la calidad de la uva y del proceso de vinificiación."]
[]
[null,"Para calcular los rendimientos de la uva se puede tomar en consideración los siguientes conceptos y estimaciones:"]
[]
[null,null,null,null,"Tasa media"]
[null,null,"Raspón",null,0.06]
[null,null,"Orujos",null,0.21]
[null,null,"Fango y Heces",null,0.03]
[null,null,"Mosto final",null,{"$f":"1-SUM(E32:E34)","v":0.7}]
["Mermas en el proceso de previnificación"]
["Sobre el vino potencial, las pérdidas promedio derivadas de la fermentación y mezclas",null,null,null,null,null,1.2E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Nota 4: Proceso Vinificación Complementaria"]
[null,"En color azul debemos personalizar el nombre y clave de nuestros vinos."]
[null,"Las pérdidas estimadas por mezclas, clarificación y estabilización, trasiegos y similares asciende a 1,75%"]
[]
[null,"Respecto a los trasiegos y al fltrado cuando se pregunta el número de depósitos a usar se hace referencia al número necesario a parte del actualmente usado. "]

{"sheet":"Notas_contables","index":6,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,10,4,15],[7,10,9,15],[4,1,5,6],[6,1,7,6],[35,1,38,6],[27,1,28,6],[15,10,16,15],[20,10,22,15],[31,1,32,6],[29,1,30,6],[16,1,19,6],[8,1,11,6],[20,1,23,6],[15,1,15,6],[3,1,3,6]]}
[]
[]
["Nota 1: Consideraciones generales",null,null,null,null,null,null,null,null,"Nota 5: Gastos de personal"]
[null,"Debe cumplimentar los siguientes datos contables (total y/o por áreas) para convertirlos en costes",null,null,null,null,null,null,null,null,"Se recogen todos los gastos / costes relacionados con el personal de la empresa correspondiente al periodo"]
[null,"Se podrá tomar considerar la partida en términos de gasto contable y convertirla en costes o bien como costes estimados o calculados. En ambos casos se procederá asignar a los centros"]
[]
[null,"El departamento de cultivo al igual que el de bodega son centros principales operativos. El primero cultivo recoge el coste total de las actividades normales vinculadas directamente a la producción de uva del periodo.",null,null,null,null,null,null,null,"Nota 6: Amortizaciones"]
[null,null,null,null,null,null,null,null,null,null,"En este apartdo se recogen los gastos de amortizacion agrupados básicamente en dos categorias, funcional (depreciacion o perdida derivada por el uso) y técnico/fisico derivado del enevejeciiento tecnologico o por el paso del tiempo"]
[null,"El centro o departamento “Gastos Plurianuales y Ajustes” pretende recoger aquellas partidas de gastos de carácter extraordinario (Reparación extraordinaria del edificio, Reparación extra del equipo de frio, etc...) y que no deben imputarse como costes del producto ni del periodo, por tanto permite convertir el gasto en coste a través del ajuste de valor. Estos valores o ajustes deben tener su correspondencia o consideración en el apartado “69 Otras Dotaciones”  o Provisiones de Costes."]
[]
[]
[]
[]
[]
["Nota 2: Consumos de explotación",null,null,null,null,null,null,null,null,"Nota 7: Otros gastos \"no de explotación\""]
[null,"Considerar los valores netos de cada partida deducidos los descuentos",null,null,null,null,null,null,null,null,"En este apartado se incluyen el resto de partidas que no forman parte de los gastos de explotación, ademas del concepto Otras Dotaciones comentadas en el apartado o nota 1"]
[null,"Las uvas compradas no tienen que coincidir con las consumidas en el caso de que exista producción propia. Las primeras pasan al proceso de producción asignándola al centro Bodega, mientras que las producidas serán los costes del periodo relacionados acumulados en el centro o departamento principal operativo Cultivo siempre y cuando estas no hubiéramos estimados el coste."]
[]
[]
[null,null,null,null,null,null,null,null,null,"Nota 8: Coste de oportunidad"]
[null,"En el caso de que la uva propia se hubiera estimado su valor este pasaría directamente al departamento de cultivo y por tanto el resto de gastos o costes de explotación del citado departamento principal operativo “Cultivo” no se tendría en cuenta porque si no estaríamos duplicando el coste",null,null,null,null,null,null,null,null,"Los valores asignados en este apartado corresponden a las estimaciones asociadas al coste de oportunidad en base a una tasa de interes sobre el capital invertido u otro criterio considerado para su evaluación"]
[]
[]
[]
[]
[]
["Nota 3: Servicios exteriores"]
[null,"En Servicios Profesionales Independientes se incluyen tanto la asistencia técnica de laboratorios y similares como la asesorisa contable y fiscal, abogados, nóminas, etc."]
[]
[null,"En la partida Suministros y Comunicaciones se recogen los gastos/costes derivados de agua, electricidad, gas, combustible (gasoil y gasolina) y similares."]
[]
[null,"En Otros se incluyen aquellas partidas que no tienen cabida especifica en los apartados anteriores como son las primas de seguro, seguridad, limpieza, etc"]
[]
[]
["Nota 4: Impuestos"]
[null,"La partida  Impuestos recogen todos aquellos concpetos impositivos agrupados en dos apartados los vinculados con la explotación como son los de impuestos sobre el alcohol, de reciclaje de vidrios, contribuciones rusticas de los terrrenos, actividades economicas, etc, y los no vinculados con la actividad como los de vado de garaje y similares."]

{"sheet":"Configuracion","index":7,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[35,1,36,4],[40,1,42,4],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4]]}
["CONFIGURACION - ADPATACION GENERAL"]
["Pestaña Radiografia del Gasto"]
[null,"GASTOS DEL PERIODO (Contabilidad) - RADIOGRAFIA DEL GASTO"]
[null,"Valores Estandar del Perfil de Bodega"]
[]
[null,"Dpto 1","Dpto 2","Dpto 3","Dpto 4"]
[null,"Finca o Cultivo","Bodega o Industrial","Comercial y Logistica","Administ. Estructura"]
[]
[]
[null,"Actividad Estimada del Periodo"]
[null,"Valores Estandar Vino a producir"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Joven Blanco Semiseco","Tinto Crianza","Tinto Barrica","Tinto Reserva"]
[]
[null,"Bag in Box","Bot 3/4","Bot 3/4","Bot 3/4"]
[]
[null,"Valores Estandar Vino a comercializar"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Joven Blanco Semiseco","Tinto Crianza X-1","Tinto Barrica X-1","Tinto Reserva X-3"]
[]
[null,"Bag in Box","Bot 3/4","Bot 3/4","Bot 3/4"]
[]
[null,"Precios promedios de los vinos a comercializar"]
[]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Valores Estandar Unitarios"]
[null,25,6.18,15.25,18.45]
[null,{"$f":"B27*100","v":2500},{"$f":"C27*100","v":618},1525,1845]
[null,"Precio Maximo Unitario"]
[null,30,8,20,25]
[null,{"$f":"B30*100","v":3000},{"$f":"C30*100","v":800},2000,2500]
[null,"Precio Mínimo "]
[null,15,4.5,12,15]
[null,{"$f":"B33*100","v":1500},{"$f":"C33*100","v":450},1200,1500]
[null,"Variación Boton (Small Change)"]
[null,"cantidad de valores que la barra avanzará al hacer clic sobre los botones de avance o retroceso (flecha)."]
[]
[null,0.5,0.1,0.15,0.2]
[null,{"$f":"B38*100","v":50},{"$f":"C38*100","v":10},15,20]
[null,"Variación Interna (Large Change)"]
[null,"cantidad de valores que la barra de desplazamiento se moverá cuando el usuario haga clic en el área que se encuentre entre la caja de desplazamiento y cualquier de las flechas de desplazamiento"]
[]
[]
[null,1,0.25,0.5,0.5]
[null,{"$f":"B44*100","v":100},{"$f":"C44*100","v":25},50,50]
[]
[null,"Coste Medio de la Uva para tipo de Vinos"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Valores Estandar Unitarios"]
[null,0.9,1.2,1.7,1.1000000000000001]
[null,{"$f":"B50*100","v":90},{"$f":"C50*100","v":120},170,110.00000000000001]
[null,"Precio Máx","Precio Min","Small ","Large"]
[null,5,0.1,0.05,0.2]
[null,{"$f":"B53*100","v":500},10,5,20]

{"sheet":"GRAFICO1","index":8,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":true,"merged":[[3,12,3,13],[4,12,4,13],[3,1,3,2],[4,1,4,2],[7,2,7,4],[7,6,7,9]]}
[]
[]
[null,"Entrada de datos",null,null,null,null,"Tasa de Variación",{"$f":"(O5-D5)/D5","v":0},null,null,null,null,"Entrada de datos"]
[null,"Nombre de la serie:",null,"Estimado",null,null,null,null,null,null,null,null,"Nombre de la serie:",null,"Sensibilidad",null,null,null,null,"Ingresos"]
[null,"Valor Actual:",null,{"$f":"CM_Produccion!M18","v":2.6294687609893335},null,null,null,null,null,null,null,null,"Valor Actual:",null,{"$f":"CM_Produccion!M26","v":2.6294687609893335}]
[]
[]
[null,null,"ESTIMADO",null,null,null,"SENSIBILIDAD"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasa de Variación:"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"D22","v":3.2868359512366667}]
[]
[]
[]
[]
[null,"Datos de calculo"]
[null,null,"Mínimo:",{"$f":"D23*0.75","v":1.9721015707420002}]
[null,null,"Máximo:",{"$f":"MAX(D5,O5)*1.25","v":3.2868359512366667}]
[null,null,"Medio:",{"$f":"(D5+O5)/2","v":2.6294687609893335}]
[]
[]
[null,null,null,"x","y",null,null,null,null,null,null,null,null,"x","y"]
[null,null,"Value",0,0,"Center","Angle",null,null,null,null,null,"Value",0,0,"Center","Angle"]
[null,null,{"$f":"D5","v":2.6294687609893335},{"$f":"(D34*COS(G28*PI()/180))","v":2.756584023544395E-16},{"$f":"(D34*SIN(G28*PI()/180))","v":4.5},"Vector",{"$f":"IF(C28*D36+D35<0,-5,C28*D36+D35)","v":90},null,null,null,null,null,{"$f":"O5","v":2.6294687609893335},{"$f":"(N34*COS(Q28*PI()/180))","v":2.756584023544395E-16},{"$f":"(N34*SIN(Q28*PI()/180))","v":4.5},"Vector",{"$f":"IF(M28*N36+N35<0,-5,M28*N36+N35)","v":90}]
[]
[null,null,null,{"$f":"(D34*COS((D35)*PI()/180))","v":-2.618510876878366E-15},{"$f":"(D34*SIN(D35*PI()/180))","v":4.5},"Cero",null,null,null,null,null,null,null,{"$f":"(N34*COS((N35)*PI()/180))","v":-2.618510876878366E-15},{"$f":"(N34*SIN(N35*PI()/180))","v":4.5},"Cero"]
[]
[]
[]
[null,null,null,4.5,"Radius",null,null,null,null,null,null,null,null,4.5,"Radius"]
[null,null,null,{"$f":"-D22*180/(D21-D22)","v":450.00000000000006},"Const",null,null,null,null,null,null,null,null,{"$f":"-D22*180/(D21-D22)","v":450.00000000000006},"Const"]
[null,null,null,{"$f":"180/(D21-D22)","v":-136.90978396128602},"Grad",null,null,null,null,null,null,null,null,{"$f":"180/(D21-D22)","v":-136.90978396128602},"Grad"]

{"sheet":"GRAFICO2","index":9,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":true,"merged":[[18,2,18,7],[2,7,2,8],[7,1,7,3],[7,14,7,16],[7,5,7,7],[3,1,3,2],[3,12,3,13],[4,1,4,2],[4,12,4,13]]}
[]
[]
[null,"Entrada de datos",null,null,null,null,"Tasa de Variación",{"$f":"(O5-D5)/D5","v":-3.7298863500960771E-16},null,null,null,null,"Entrada de datos"]
[null,"Nombre de la serie:",null,"Estimado",null,null,null,null,null,null,null,null,"Nombre de la serie:",null,"Sensibilidad",null,null,null,null,"Ingresos"]
[null,"Valor Actual:",null,{"$f":"CM!I29","v":39014.366290254431},null,null,null,null,null,null,null,null,"Valor Actual:",null,{"$f":"CM!I30","v":39014.366290254417}]
[]
[]
[null,"ESTIMADO",null,null,null,"SIMULACION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Punto Muerto"]
[]
[]
[]
[]
[]
[]
[null,null,null,"x","y",null,null,null,null,null,null,null,null,"x","y"]
[null,null,"Value",0,0,"Center","Angle",null,null,null,null,null,"Value",0,0,"Center","Angle"]
[null,null,{"$f":"D5","v":39014.366290254431},{"$f":"(D34*COS(G28*PI()/180))","v":8.2692641796555666E-15},{"$f":"(D34*SIN(G28*PI()/180))","v":4.5},"Vector",{"$f":"IF(C28*D36+D35<0,-5,C28*D36+D35)","v":89.999999999999886},null,null,null,null,null,{"$f":"O5","v":39014.366290254417},{"$f":"(N34*COS(Q28*PI()/180))","v":-3.721144486296124E-15},{"$f":"(N34*SIN(Q28*PI()/180))","v":4.5},"Vector",{"$f":"IF(M28*N36+N35<0,-5,M28*N36+N35)","v":90.000000000000057}]
[]
[null,null,null,{"$f":"(D34*COS((D35)*PI()/180))","v":1.7365503566374452E-14},{"$f":"(D34*SIN(D35*PI()/180))","v":4.5},"Cero",null,null,null,null,null,null,null,{"$f":"(N34*COS((N35)*PI()/180))","v":1.7365503566374452E-14},{"$f":"(N34*SIN(N35*PI()/180))","v":4.5},"Cero"]
[]
[null,null,null,null,null,null,null,null,null,"Datos de calculo"]
[null,null,null,null,null,null,null,null,null,null,"Mínimo:",{"$f":"L35*0.75","v":29260.774717690816}]
[null,null,null,4.5,"Radius",null,null,null,null,null,"Máximo:",{"$f":"MAX(D5,O5)*1.25","v":48767.957862818039},null,4.5,"Radius"]
[null,null,null,{"$f":"-L34*180/(L33-L34)","v":449.99999999999977},"Const",null,null,null,null,null,"Medio:",{"$f":"(D5+O5)/2","v":39014.366290254424},null,{"$f":"-L34*180/(L33-L34)","v":449.99999999999977},"Const"]
[null,null,null,{"$f":"180/(L33-L34)","v":-9.2273701774806434E-3},"Grad",null,null,null,null,null,null,null,null,{"$f":"180/(L33-L34)","v":-9.2273701774806434E-3},"Grad"]

{"sheet":"Configuracioncopia","index":10,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":true,"merged":[[35,1,36,4],[40,1,42,4],[18,1,19,1],[18,2,19,2],[18,3,19,3],[18,4,19,4],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4]]}
["CONFIGURACION - ADPATACION GENERAL"]
["Pestaña Radiografia del Gasto"]
[null,"GASTOS DEL PERIODO (Contabilidad) - RADIOGRAFIA DEL GASTO"]
[null,"Valores Estandar del Perfil de Bodega"]
[]
[null,"Dpto 1","Dpto 2","Dpto 3","Dpto 4"]
[null,"Cultivo","Bodega o Industrial","Comercial y Logistica","Administ. Estructura"]
[]
[]
[null,"Actividad Estimada del Periodo"]
[null,"Valores Estandar Vino a producir"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Joven Blanco Semiseco","Tinto Crianza","Tinto Barrica","Tinto Reserva"]
[]
[null,"Bag in Box","Bot 3/4","Bot 3/4","Bot 3/4"]
[]
[null,"Valores Estandar Vino a comercializar"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Joven Blanco Semiseco","Tinto Crianza X-1","Tinto Barrica X-1","Tinto Reserva X-3"]
[]
[null,"Bag in Box","Bot 3/4","Bot 3/4","Bot 3/4"]
[]
[null,"Precios promedios de los vinos a comercializar"]
[]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Valores Estandar Unitarios"]
[null,25,6.18,15.25,18.45]
[null,{"$f":"B27*100","v":2500},{"$f":"C27*100","v":618},1525,1845]
[null,"Precio Maximo Unitario"]
[null,30,8,20,25]
[null,{"$f":"B30*100","v":3000},{"$f":"C30*100","v":800},2000,2500]
[null,"Precio Mínimo "]
[null,15,4.5,12,15]
[null,{"$f":"B33*100","v":1500},{"$f":"C33*100","v":450},1200,1500]
[null,"Variación Boton (Small Change)"]
[null,"cantidad de valores que la barra avanzará al hacer clic sobre los botones de avance o retroceso (flecha)."]
[]
[null,0.5,0.1,0.15,0.2]
[null,{"$f":"B38*100","v":50},{"$f":"C38*100","v":10},15,20]
[null,"Variación Interna (Large Change)"]
[null,"cantidad de valores que la barra de desplazamiento se moverá cuando el usuario haga clic en el área que se encuentre entre la caja de desplazamiento y cualquier de las flechas de desplazamiento"]
[]
[]
[null,1,0.25,0.5,0.5]
[null,{"$f":"B44*100","v":100},{"$f":"C44*100","v":25},50,50]
[]
[null,"Coste Medio de la Uva para tipo de Vinos"]
[null,"Vino 1","Vino 2","Vino 3","Vino 4"]
[null,"Valores Estandar Unitarios"]
[null,0.9,1.2,1.7,1.1000000000000001]
[null,{"$f":"B50*100","v":90},{"$f":"C50*100","v":120},170,110.00000000000001]
[null,"Precio Máx","Precio Min","Small ","Large"]
[null,5,0.1,0.05,0.2]
[null,{"$f":"B53*100","v":500},10,5,20]